package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class Demo3 {
    public static void main(String[] args) throws Exception {
        Connection  connection=DBUtil.getConnection();
        Statement statement=connection.createStatement();
        /*
        Update user
        SET password='666666',nickname='老三',age=33
        WHERE id=1
         */
        String sql="  UPDATE user\n" +
                "        SET password='666666',nickname='老三',age=33\n" +
                "        WHERE id=1";
        System.out.println(sql);
        int num=statement.executeUpdate(sql);
        if (num>0){
            System.out.println("修改完毕,影响了表中"+num+"条数据");
        }else {
            System.out.println("修改失败");
        }
        connection.close();
    }
}
